package sqlDb;
/**
 * Created by Administrator on 2016/12/2 0002.
 */

import java.sql.*;
import java.util.ArrayList;

public class Data {
    public static ArrayList<emailAr> emailArDb = new ArrayList<>();
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String url = null;
        String user = null;
        String password = null;
        String sql = null;
    public ArrayList<emailAr>Data() {
        try {
            Class.forName("com.mysql.jdbc.Driver"); //加载mysq驱动
        } catch (ClassNotFoundException e) {
            System.out.println("驱动加载错误");
            e.printStackTrace();//打印出错详细信息
        }
        try {
            url =
                    "jdbc:mysql://localhost/emaildb?user=root&password&useUnicode=true&&characterEncoding=gb2312&useSSL=false";//简单写法：url = "jdbc:myqsl://localhost/test(数据库名)? user=root(用户)&password=yqs2602555(密码)";
            user = "root";
            password = "";
            conn = DriverManager.getConnection(url, user, password);
        } catch (SQLException e) {
            System.out.println("数据库链接错误");
            e.printStackTrace();
        }
        try {
            stmt = conn.createStatement();
            sql = "select * from email";//dept这张表有deptno，deptname和age这三个字段
            rs = stmt.executeQuery(sql);//执行sql语句
            while (rs.next()) {
                emailAr em = new emailAr();
                em.id = rs.getInt("id");
                em.address = rs.getString("address");
                em.name = rs.getString("name");
                emailArDb.add(em);
            }
        } catch (SQLException e) {
            System.out.println("数据操作错误");
            e.printStackTrace();
        }
//关闭数据库
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (stmt != null) {
                stmt.close();
                stmt = null;
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }
        } catch (Exception e) {
            System.out.println("数据库关闭错误");
            e.printStackTrace();
        }
        return emailArDb;
    }
}

